{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Part_materia_prima","Ejemplo ICE 2021","Formulario_ICE","Tabla_Exoneración","Formulario ICE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Part_materia_prima","index":0,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,1],[11,3,11,6],[33,5,33,9],[33,2,33,3],[33,0,33,1],[9,0,9,11]]}
["TABLA VIGENTE PARA 2018 Y 2019"]
["Participación",null,"Rebaja en tarifa ICE específico"]
["DESDE","HASTA","%"]
[0.05,0.1,0.05]
[0.10009999999999999,0.2,0.1]
[0.2001,0.3,0.2]
[0.3,0.4,0.3]
[0.40010000000000001,0.5,0.4]
[0.50009999999999999,1,0.5]
["CALCULO DE LA PARTICIPACIÓN Y REBAJA EN LA TARIFA ESPECÍFICA A PARTIR DE ENERO 2019"]
[]
[null,null,null,"JUSTIFICADO CON COMPROBANTES DE VENTA VÁLIDOS"]
["#","AÑO","MES","AGUARDIENTE Y ALCOHOL SIN BENEFICIO","ALCOHOL ARTESANAL/EPS","AGUARDIENTE ARTESANAL/EPS","TOTAL COMPRAS","TOTAL COMPRAS ÚLTIMOS 6 MESES","AGUARDIENTE Y ALCOHOL  PRIMA PARA BENEFICIO","TOTAL COMPRAS CON BENEFICIO","PARTICIPACIÓN","% REDUCCCIÓN EN TARIFA ESPECÍFICA"]
[1,2018,"JULIO",null,null,null,{"$f":"SUM(D14:F14)","v":0},null,{"$f":"SUM(E14:F14)","v":0}]
[2,2018,"AGOSTO",null,null,null,{"$f":"SUM(D15:F15)","v":0},null,{"$f":"SUM(E15:F15)","v":0}]
[3,2018,"SEPTIEMBRE",null,null,null,0,{"$f":"SUM(G14:G15)","v":0},0,{"$f":"SUM(I14:I15)","v":0},{"$f":"+J16/H16","v":{"$error":"#DIV/0!"}},{"$f":"+IF(K16<5%,0%,IF(K16<=$B$4,5%,IF(K16<=$B$5,10%,IF(K16<=$B$6,20%,IF(K16<=$B$7,30%,IF(K16<=$B$8,40%,IF(K16<=$B$9,50%,\"REVISAR\")))))))","v":{"$error":"#DIV/0!"}}]
[4,2018,"OCTUBRE",null,null,null,0,{"$f":"SUM(G14:G16)","v":0},0,{"$f":"SUM(I14:I16)","v":0},{"$f":"+J17/H17","v":{"$error":"#DIV/0!"}},{"$f":"+IF(K17<5%,0%,IF(K17<=$B$4,5%,IF(K17<=$B$5,10%,IF(K17<=$B$6,20%,IF(K17<=$B$7,30%,IF(K17<=$B$8,40%,IF(K17<=$B$9,50%,\"REVISAR\")))))))","v":{"$error":"#DIV/0!"}}]
[5,2018,"NOVIEMBRE",null,null,null,0,{"$f":"SUM(G14:G17)","v":0},0,{"$f":"SUM(I14:I17)","v":0},{"$f":"+J18/H18","v":{"$error":"#DIV/0!"}},{"$f":"+IF(K18<5%,0%,IF(K18<=$B$4,5%,IF(K18<=$B$5,10%,IF(K18<=$B$6,20%,IF(K18<=$B$7,30%,IF(K18<=$B$8,40%,IF(K18<=$B$9,50%,\"REVISAR\")))))))","v":{"$error":"#DIV/0!"}}]
[6,2018,"DICIEMBRE",null,null,null,0,{"$f":"SUM(G14:G18)","v":0},0,{"$f":"SUM(I14:I18)","v":0},{"$f":"+J19/H19","v":{"$error":"#DIV/0!"}},{"$f":"+IF(K19<5%,0%,IF(K19<=$B$4,5%,IF(K19<=$B$5,10%,IF(K19<=$B$6,20%,IF(K19<=$B$7,30%,IF(K19<=$B$8,40%,IF(K19<=$B$9,50%,\"REVISAR\")))))))","v":{"$error":"#DIV/0!"}}]
[7,2019,"ENERO",null,null,null,{"$f":"SUM(D20:F20)","v":0},{"$f":"SUM(G14:G19)","v":0},{"$f":"SUM(E20:F20)","v":0},{"$f":"SUM(I14:I19)","v":0},{"$f":"+J20/H20","v":{"$error":"#DIV/0!"}},{"$f":"+IF(K20<5%,0%,IF(K20<=$B$4,5%,IF(K20<=$B$5,10%,IF(K20<=$B$6,20%,IF(K20<=$B$7,30%,IF(K20<=$B$8,40%,IF(K20<=$B$9,50%,\"REVISAR\")))))))","v":{"$error":"#DIV/0!"}}]
[8,2019,"FEBRERO",null,null,null,0,{"$f":"SUM(G15:G20)","v":0},0,{"$f":"SUM(I15:I20)","v":0},{"$f":"+J21/H21","v":{"$error":"#DIV/0!"}},{"$f":"+IF(K21<5%,0%,IF(K21<=$B$4,5%,IF(K21<=$B$5,10%,IF(K21<=$B$6,20%,IF(K21<=$B$7,30%,IF(K21<=$B$8,40%,IF(K21<=$B$9,50%,\"REVISAR\")))))))","v":{"$error":"#DIV/0!"}}]
[9,2019,"MARZO",null,null,null,0,{"$f":"SUM(G16:G21)","v":0},0,{"$f":"SUM(I16:I21)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[10,2019,"ABRIL",null,null,null,0,{"$f":"SUM(G17:G22)","v":0},0,{"$f":"SUM(I17:I22)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[11,2019,"MAYO",null,null,null,0,{"$f":"SUM(G18:G23)","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12,2019,"JUNIO",null,null,null,0,{"$f":"SUM(G19:G24)","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[13,2019,"JULIO",null,null,null,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[14,2019,"AGOSTO",null,null,null,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[15,2019,"SEPTIEMBRE",null,null,null,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[16,2019,"OCTUBRE",null,null,null,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[17,2019,"NOVIEMBRE",null,null,null,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[18,2019,"DICIEMBRE",null,null,null,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["ESCOJA MES:",null,"FEBRERO",null,null,{"$f":"+IF(L13=0%,\"NO TIENE REBAJA EN ICE ESPECÍFICO\",\"LA REDUCCIÓN EN LA TARIFA ESPECÍFICA ES DE:\")","v":"LA REDUCCIÓN EN LA TARIFA ESPECÍFICA ES DE:"},null,null,null,null,{"$f":"+IF(C34=\"ENERO\",L20,IF(C34=\"FEBRERO\",L21,IF(C34=\"MARZO\",L22,IF(C34=\"ABRIL\",L23,IF(C34=\"MAYO\",L24,IF(C34=\"JUNIO\",L25,IF(C34=\"JULIO\",L26,IF(C34=\"AGOSTO\",L27,IF(C34=\"SEPTIEMBRE\",L28,IF(C34=\"OCTUBRE\",L29,IF(C34=\"NOVIEMBRE\",L30,IF(C34=\"DICIEMBRE\",L31,\"REVISAR\"))))))))))))","v":{"$error":"#DIV/0!"}}]
[]
[]
["Nota: El contribuyente deberá ingresar los datos en los campos resaltados en amarillo de acuerdo a su propia información. "]

{"sheet":"Ejemplo ICE 2021","index":1,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[46,2,46,6],[27,1,27,8],[0,1,0,6],[14,2,14,5],[23,1,23,8],[7,2,7,5],[25,1,25,8],[21,2,21,4]]}
[null,"DATOS DE LAS BEBIDAS ALCOHÓLICAS:"]
[]
[null,"TIPO DE BEBIDA","PRECIO DE VENTA DEL FABRICANTE/PRECIO EXADUANA","UNIDADES A VENDER/IMPORTAR","GRADO ALCOHÓLICO","CAPACIDAD (ml/cc)"]
[null,"AGUARDIENTE",2.78,1,0.47,750]
[null,"LICOR SECO",3,1,0.3,500]
[null,"COCTEL",5.25,1,0.2,375]
[]
[null,null,"ICE AD VALOREM:"]
[null,"TIPO DE BEBIDA","BASE BRUTA\n(Casillero 303)","BASE NETA\n(Casillero 303)","% Tarifa ad valorem\n(Casillero 305)","ICE CAUSADO ADVALOREM\n(Casillero 309)"]
[null,{"$f":"+B33","v":"AGUARDIENTE"},{"$f":"+IF(C4*1000/F4>4.29,(C4-(4.29*F4/1000))*D4,0)","v":0},{"$f":"+C10","v":0},0.75,{"$f":"+D10*E10","v":0}]
[null,{"$f":"+B34","v":"LICOR SECO"},{"$f":"+IF(C5*1000/F5>4.29,(C5-(4.29*F5/1000))*D5,0)","v":0.85499999999999998},{"$f":"+C11","v":0.85499999999999998},0.75,{"$f":"+D11*E11","v":0.64124999999999999}]
[null,{"$f":"+B35","v":"COCTEL"},{"$f":"+IF(C6*1000/F6>4.29,(C6-(4.29*F6/1000))*D6,0)","v":3.6412500000000003},{"$f":"+C12","v":3.6412500000000003},0.75,{"$f":"+D12*E12","v":2.7309375000000005}]
[null,null,{"$f":"SUM(C10:C12)","v":4.4962499999999999},{"$f":"+C13","v":4.4962499999999999},null,{"$f":"SUM(F10:F12)","v":3.3721875000000003}]
[]
[null,null,"ICE ESPECÍFICO:"]
[null,"TIPO DE BEBIDA","VOLUMEN BRUTO","VOLUMEN NETO","TARIFA ESPECÍFICA","ICE ESPECÍFICO"]
[null,{"$f":"+B10","v":"AGUARDIENTE"},{"$f":"+F4*E4*D4/1000","v":0.35249999999999998},{"$f":"+C17","v":0.35249999999999998},10,{"$f":"+C17*E17","v":3.5249999999999999}]
[null,{"$f":"+B11","v":"LICOR SECO"},{"$f":"+F5*E5*D5/1000","v":0.15},{"$f":"+C18","v":0.15},10,{"$f":"+C18*E18","v":1.5}]
[null,{"$f":"+B12","v":"COCTEL"},{"$f":"+F6*E6*D6/1000","v":7.4999999999999997E-2},{"$f":"+C19","v":7.4999999999999997E-2},10,{"$f":"+C19*E19","v":0.75}]
[null,null,{"$f":"SUM(C17:C19)","v":0.5774999999999999},{"$f":"SUM(D17:D19)","v":0.5774999999999999},null,{"$f":"SUM(F17:F19)","v":5.7750000000000004}]
[]
[null,null,"ICE TOTAL CAUSADO SIN BENEFICIOS",null,null,{"$f":"+F13+F20","v":9.1471875000000011}]
[]
[null,"ANÁLISIS DE EXONERACIÓN Y REBAJA"]
[]
[null,"ANÁLISIS DE INGREDIENTES NACIONALES: Se realiza por cada bebida alcohólica, con su respectiva Notificación Sanitaria y excluyendo el agua. Los productores de ingredientes nacionales deben ser artesanos, micros o de la EPS; y adicionalmente deben constar en el listado de MAG o MPCEIP."]
[]
[null,"El sujeto pasivo debe cumplir con todos y cada uno de los requisitos y condiciones establecidos en la normativa tributaria vigente. El incumplmiento de un requisto o condición, no le permite acceder a los beneficios, debiendo calcular el ICE sin ningún tipo de exoneración y/o rebaja. "]
[]
[null,"EXONERACIÓN"]
[]
[null,"TIPO DE BEBIDA","% INGREDIENTES NACIONALES","OBSERVACIÓN","% EXENCIÓN\n(ver tabla en resolución)","ICE AD VALOREM","ICE ESPECÍFICO","TOTAL ICE","VALOR EXENCIÓN \n(Casillero 326)"]
[null,{"$f":"+B4","v":"AGUARDIENTE"},1,{"$f":"+IF(C33<=70%,\"No aplica beneficios\",\"Sí aplica beneficios\")","v":"Sí aplica beneficios"},{"$f":"+IF(C33<=69.99%,\"0%\",IF(C33<=75%,\"0,5%\",IF(C33<=80%,\"1,0%\",IF(C33<=85%,\"1,5%\",IF(C33<=90%,\"2,0%\",IF(C33<=95%,\"3,0%\",IF(C33<=99%,\"4,0%\",IF(C33<=100%,\"5,0\"%))))))))","v":0.05},{"$f":"+F10","v":0},{"$f":"+F17","v":3.5249999999999999},{"$f":"+F33+G33","v":3.5249999999999999},{"$f":"+E33*H33","v":0.17625000000000002}]
[null,{"$f":"+B5","v":"LICOR SECO"},1,{"$f":"+IF(C34<=70%,\"No aplica beneficios\",\"Sí aplica beneficios\")","v":"Sí aplica beneficios"},{"$f":"+IF(C34<=69.99%,\"0%\",IF(C34<=75%,\"0,5%\",IF(C34<=80%,\"1,0%\",IF(C34<=85%,\"1,5%\",IF(C34<=90%,\"2,0%\",IF(C34<=95%,\"3,0%\",IF(C34<=99%,\"4,0%\",IF(C34<=100%,\"5,0\"%))))))))","v":0.05},{"$f":"+F11","v":0.64124999999999999},{"$f":"+F18","v":1.5},{"$f":"+F34+G34","v":2.1412499999999999},{"$f":"+E34*H34","v":0.1070625}]
[null,{"$f":"+B6","v":"COCTEL"},0.2,{"$f":"+IF(C35<=70%,\"No aplica beneficios\",\"Sí aplica beneficios\")","v":"No aplica beneficios"},{"$f":"+IF(C35<=69.99%,\"0%\",IF(C35<=75%,\"0,5%\",IF(C35<=80%,\"1,0%\",IF(C35<=85%,\"1,5%\",IF(C35<=90%,\"2,0%\",IF(C35<=95%,\"3,0%\",IF(C35<=99%,\"4,0%\",IF(C35<=100%,\"5,0\"%))))))))","v":"0%"},{"$f":"+F12","v":2.7309375000000005},{"$f":"+F19","v":0.75},{"$f":"+F35+G35","v":3.4809375000000005},{"$f":"+E35*H35","v":0}]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I33:I35)","v":0.28331250000000002}]
[]
[null,"REBAJA"]
[]
[null,"TIPO DE BEBIDA","% INGREDIENTES NACIONALES","OBSERVACIÓN","VOLUMEN NETO\nCasillero:","VOLUMEN BRUTO","VOLUMEN NETO","TARIFA ESPECÍFICA","ICE ESPECÍFICO"]
[null,{"$f":"+B33","v":"AGUARDIENTE"},{"$f":"+C33","v":1},{"$f":"+IF(C41<=70%,\"No aplica beneficios\",\"Sí aplica beneficios\")","v":"Sí aplica beneficios"},{"$f":"+IF(D41=\"No aplica beneficios\",\"Casillero 314\",\"Casillero 316\")","v":"Casillero 316"},{"$f":"+IF(D41=\"No aplica beneficios\", D4*F4*E4/1000,D4*E4*F4/1000)","v":0.35249999999999998},{"$f":"+F41","v":0.35249999999999998},{"$f":"+IF(D41=\"No aplica beneficios\",10, 10*50%)","v":5},{"$f":"+G41*H41","v":1.7625}]
[null,{"$f":"+B34","v":"LICOR SECO"},{"$f":"+C34","v":1},{"$f":"+IF(C42<=70%,\"No aplica beneficios\",\"Sí aplica beneficios\")","v":"Sí aplica beneficios"},{"$f":"+IF(D42=\"No aplica beneficios\",\"Casillero 314\",\"Casillero 316\")","v":"Casillero 316"},{"$f":"+IF(D42=\"No aplica beneficios\", D5*F5*E5/1000,D5*E5*F5/1000)","v":0.15},{"$f":"+F42","v":0.15},{"$f":"+IF(D42=\"No aplica beneficios\",10, 10*50%)","v":5},{"$f":"+G42*H42","v":0.75}]
[null,{"$f":"+B35","v":"COCTEL"},{"$f":"+C35","v":0.2},{"$f":"+IF(C43<=70%,\"No aplica beneficios\",\"Sí aplica beneficios\")","v":"No aplica beneficios"},{"$f":"+IF(D43=\"No aplica beneficios\",\"Casillero 314\",\"Casillero 316\")","v":"Casillero 314"},{"$f":"+IF(D43=\"No aplica beneficios\", D6*F6*E6/1000,D6*E6*F6/1000)","v":7.4999999999999997E-2},{"$f":"+F43","v":7.4999999999999997E-2},{"$f":"+IF(D43=\"No aplica beneficios\",10, 10*50%)","v":10},{"$f":"+G43*H43","v":0.75}]
[null,null,null,null,null,{"$f":"SUM(F41:F43)","v":0.5774999999999999},{"$f":"SUM(G41:G43)","v":0.5774999999999999},"Total",{"$f":"SUM(I41:I43)","v":3.2625000000000002}]
[]
[]
[null,null,"RESUMEN"]
[]
[null,null,"ICE AD VALOREM SIN EXONERACIÓN","ICE ESPECÍFICO SIN BENEFICIOS","EXONERACIÓN ICE","REBAJA ICE","VALOR A PAGAR",null,null,null,null,null,null,null,null,{"$f":"+H36-#REF!-F51","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"+F13","v":3.3721875000000003},{"$f":"+F20","v":5.7750000000000004},{"$f":"+I36","v":0.28331250000000002},{"$f":"+Formulario_ICE!R9","v":2.5124999999999997},{"$f":"+C50+D50-E50-F50","v":6.3513750000000027}]

{"sheet":"Formulario_ICE","index":2,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,9],[0,10,0,17],[1,0,1,5],[1,8,1,9],[1,10,1,15],[2,0,2,5],[2,8,2,9],[2,10,2,15],[3,0,3,5],[3,8,3,9],[3,10,3,15],[4,0,4,5],[4,8,4,9],[4,10,4,15],[5,0,5,7],[5,8,5,9],[5,10,5,17],[6,0,6,5],[6,8,6,9],[6,10,6,15],[7,0,7,5],[7,8,7,9],[7,10,7,15],[8,0,8,5],[8,8,8,9],[8,10,8,15],[9,0,9,5],[9,8,9,9],[9,10,9,15],[10,0,10,5],[10,8,10,9],[11,0,11,5],[11,8,11,9],[10,10,10,15],[11,10,11,17],[12,0,12,5],[12,8,12,9],[12,10,12,17],[13,0,13,5],[13,8,13,9],[13,10,13,17],[14,0,14,17],[15,0,15,17],[16,0,16,11],[16,12,16,15],[17,0,17,11],[17,12,17,15],[18,0,18,17],[19,0,19,17],[20,0,20,11],[20,12,20,15],[21,0,21,9],[21,10,21,15],[29,0,29,17],[22,0,22,11],[22,12,22,15],[23,0,23,17],[24,0,24,9],[24,10,24,15],[25,0,25,11],[25,12,25,15],[26,0,26,11],[26,12,26,15],[27,0,27,11],[27,12,27,15],[28,0,28,17],[37,0,37,17],[30,0,30,17],[31,0,31,11],[31,12,31,15],[32,0,32,17],[33,0,33,1],[33,2,33,15],[34,0,34,1],[34,2,34,15],[35,0,35,1],[35,2,35,15],[36,0,36,17],[41,0,41,11],[41,12,41,15],[38,0,38,11],[38,12,38,15],[39,0,39,11],[39,12,39,15],[40,0,40,11],[40,12,40,15]]}
["IMPUESTO AD VALOREM",null,null,null,null,null,null,null,null,null,"IMPUESTO ESPECÍFICO"]
["Base imponible bruta",null,null,null,null,null,"303",{"$f":"+'Ejemplo ICE 2021'!C13","v":4.4962499999999999},null,null,"Volumen bruto",null,null,null,null,null,"313",{"$f":"+'Ejemplo ICE 2021'!C19","v":7.4999999999999997E-2}]
["Base imponible neta (base imponible bruta menos devoluciones)",null,null,null,null,null,"304",{"$f":"+'Ejemplo ICE 2021'!D13","v":4.4962499999999999},".",null,"Volumen neto (volumen bruto menos devoluciones)",null,null,null,null,null,"314",{"$f":"+'Ejemplo ICE 2021'!G43","v":7.4999999999999997E-2}]
["Porcentaje tarifa ad valorem",null,null,null,null,null,"305",0.75,".",null,"Tarifa específica",null,null,null,null,null,"315",10]
["ICE causado ad valorem",null,null,null,null,null,"309",{"$f":"+H3*H4","v":3.3721874999999999},".",null,"ICE causado específico",null,null,null,null,null,"319",{"$f":"+R3*R4","v":0.75}]
["et"]
["Volumen neto de vehículos eléctricos",null,null,null,null,null,"307",0,".",null,"Volumen neto aplica tarifa reducida",null,null,null,null,null,"316",{"$f":"+'Ejemplo ICE 2021'!G41+'Ejemplo ICE 2021'!G42","v":0.50249999999999995}]
["Descuento ICE causado ad valorem",null,null,null,null,null,"310",0,".",null,"Tarifa específica reducida",null,null,null,null,null,"317",{"$f":"+R4/2","v":5}]
["Volumen neto de vehículos",null,null,null,null,null,"311",0,".",null,"Rebaja por tarifa reducida",null,null,null,null,null,"318",{"$f":"+(R7*R4)-(R7*R8)","v":2.5124999999999997}]
["ICE causado ad valorem vehículos seguridad y emisiones",null,null,null,null,null,"312",0,".",null,"ICE causado específico con tarifa reducida",null,null,null,null,null,"320",{"$f":"+R7*R8","v":2.5124999999999997}]
["Volumen neto de vehículos motorizados con seguridad y emisiones superiores euro 3",null,null,null,null,null,"330",0,".",null,"Exención ICE bebidas alcohólicas",null,null,null,null,null,"326",{"$f":"+'Ejemplo ICE 2021'!I36","v":0.28331250000000002}]
["ICE causado ad valorem vehículos motorizados con seguridad y emisiones superiores euro 3",null,null,null,null,null,"331",0,"."]
["Volumen neto de vehículos motorizados con exención",null,null,null,null,null,"328",0,"."]
["Exención ICE vehículos motorizados",null,null,null,null,null,"329",0,"."]
[0]
["ICE CAUSADO"]
["ICE pagado al momento de la desaduanización",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"321",0]
["TOTAL ICE CAUSADO",null,null,null,null,null,null,null,null,null,null,null,"309 - 310 + 312 + 319 + 320+331 -326- 321",null,null,null,"399",{"$f":"+H5-H8+H10+R5+R10+H12-R11-R17","v":6.351375}]
[]
["LIQUIDACIÓN DEL ICE EN EL MES"]
["Impuesto a liquidar el próximo mes (por ventas a crédito del período)",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"402",0]
["Impuesto a liquidar del mes anterior ",null,null,null,null,null,null,null,null,null,"(Trasládese el casillero 402 de la declaración del período anterior)",null,null,null,null,null,"403",0]
["Total impuesto a liquidar en este mes",null,null,null,null,null,null,null,null,null,null,null,"399 - 402 + 403",null,null,null,"404",{"$f":"+R18-R21+R22","v":6.351375}]
[]
["(-) Saldo mes anterior por concepto de notas de crédito",null,null,null,null,null,null,null,null,null,"(Trasládese el casillero 498 de la declaración del período anterior)",null,null,null,null,null,"410",0]
["(-) Notas de crédito del periodo",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"411",0]
["Saldo para el próximo mes por concepto de notas de crédito",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"498",0]
["TOTAL ICE A PAGAR",null,null,null,null,null,null,null,null,null,null,null,"404 - 410 - 411",null,null,null,"499",{"$f":"+R23-R25-R26","v":6.351375}]
[]
["TOTALES"]
["VALORES A PAGAR"]
["Pago previo",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"890",0]
["Detalle de imputación al pago"]
[".",null,"Interés",null,null,null,null,null,null,null,null,null,null,null,null,null,"897",0]
[".",null,"Impuesto",null,null,null,null,null,null,null,null,null,null,null,null,null,"898",0]
[".",null,"Multa",null,null,null,null,null,null,null,null,null,null,null,null,null,"899",0]
[]
["VALORES A PAGAR  (luego de imputación al pago)"]
["TOTAL IMPUESTO A PAGAR",null,null,null,null,null,null,null,null,null,null,null,"499 - 898",null,null,null,"902",{"$f":"+R28-R35","v":6.351375}]
["Interés por mora",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"903",0]
["Multa",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"904",0]
["TOTAL PAGADO",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"999",{"$f":"+R39+R40+R41","v":6.351375}]

{"sheet":"Tabla_Exoneración","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[]
["Participación de compras de ingredientes nacionales respecto de las compras totales  (inclusive importaciones) para la elaboración de bebidas alcohólicas",null,"Exención en ICE calculado sin beneficio alguno"]
["Desde","Hasta","%"]
[0,0.69989999999999997,0]
[0.7,0.75,5.0000000000000001E-3]
[0.75009999999999999,0.8,0.01]
[0.80010000000000003,0.85,1.4999999999999999E-2]
[0.85009999999999997,0.9,0.02]
[0.90010000000000001,0.95,0.03]
[0.95009999999999994,0.99,0.04]
[0.99009999999999998,1,0.05]

{"sheet":"Formulario ICE","index":4,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":true,"merged":[[2,0,2,7],[2,8,2,9],[2,10,2,17],[3,0,3,5],[3,8,3,9],[3,10,3,15],[4,0,4,5],[4,8,4,9],[4,10,4,15],[5,0,5,5],[5,8,5,9],[5,10,5,15],[6,0,6,5],[6,8,6,9],[6,10,6,15],[7,0,7,7],[7,8,7,9],[8,0,8,5],[8,8,8,9],[8,10,8,15],[9,0,9,5],[9,8,9,9],[9,10,9,15],[10,0,10,7],[10,8,10,9],[10,10,10,15],[11,0,11,7],[11,8,11,9],[11,10,11,15],[19,0,19,9],[19,10,19,15],[12,0,12,17],[13,0,13,17],[14,0,14,11],[14,12,14,15],[15,0,15,11],[15,12,15,15],[24,0,24,11],[24,12,24,15],[25,0,25,11],[25,12,25,15],[0,0,0,17],[20,0,20,11],[20,12,20,15],[21,0,21,17],[22,0,22,9],[22,10,22,15],[23,0,23,11],[23,12,23,15],[16,0,16,17],[17,0,17,17],[18,0,18,11],[18,12,18,15]]}
["FORMULARIO IMPUESTO A LOS CONSUMOS ESPECIALES"]
[]
["IMPUESTO AD VALOREM",null,null,null,null,null,null,null,".",null,"IMPUESTO ESPECÍFICO"]
["Base imponible bruta",null,null,null,null,null,"303",{"$f":"+#REF!","v":{"$error":"#REF!"}},".",null,"Volumen bruto",null,null,null,null,null,"313",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Base imponible neta (base imponible bruta menos devoluciones)",null,null,null,null,null,"304",{"$f":"+#REF!","v":{"$error":"#REF!"}},".",null,"Volumen neto (volumen bruto menos devoluciones)",null,null,null,null,null,"314",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Porcentaje tarifa ad valorem",null,null,null,null,null,"305",0.75,".",null,"Tarifa específica",null,null,null,null,null,"315",7.25]
["ICE causado ad valorem",null,null,null,null,null,"309",{"$f":"+H6*H5","v":{"$error":"#REF!"}},".",null,"ICE causado específico",null,null,null,null,null,"319",{"$f":"+ROUND((R5*R6),2)","v":{"$error":"#REF!"}}]
[]
["Volumen neto de vehículos eléctricos",null,null,null,null,null,"307",0,".",null,"Volumen neto aplica tarifa reducida",null,null,null,null,null,"316",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
["Descuento ICE causado ad valorem",null,null,null,null,null,"310",0,".",null,"Tarifa específica reducida",null,null,null,null,null,"317",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[".",null,null,null,null,null,null,null,".",null,"Rebaja por tarifa reducida",null,null,null,null,null,"318",{"$f":"R9*(R6*Part_materia_prima!K34)","v":{"$error":"#REF!"}}]
[".",null,null,null,null,null,null,null,".",null,"ICE causado específico con tarifa reducida",null,null,null,null,null,"320",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[]
["ICE CAUSADO"]
["ICE pagado al momento de la desaduanización",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"321"]
["TOTAL ICE CAUSADO",null,null,null,null,null,null,null,null,null,null,null,"309 - 310 + 319 + 320 - 321",null,null,null,"399",{"$f":"+ROUND((H7+H10+R7+R12),2)","v":{"$error":"#REF!"}}]
[]
["LIQUIDACIÓN DEL ICE EN EL MES"]
["Impuesto a liquidar el próximo mes (por ventas a crédito del período)",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"402"]
["Impuesto a liquidar del mes anterior ",null,null,null,null,null,null,null,null,null,"(Trasládese el casillero 402 de la declaración del período anterior)",null,null,null,null,null,"403"]
["Total impuesto a liquidar en este mes",null,null,null,null,null,null,null,null,null,null,null,"399 - 402 + 403",null,null,null,"404"]
[]
["(-) Saldo mes anterior por concepto de notas de crédito",null,null,null,null,null,null,null,null,null,"(Trasládese el casillero 498 de la declaración del período anterior)",null,null,null,null,null,"410"]
["(-) Notas de crédito del periodo",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"411"]
["Saldo para el próximo mes por concepto de notas de crédito",null,null,null,null,null,null,null,null,null,null,null,".",null,null,null,"498"]
["TOTAL ICE A PAGAR",null,null,null,null,null,null,null,null,null,null,null,"404 - 410 - 411",null,null,null,"499"]